SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531080 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531080 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002016,6482,497722,955771,836442,398290,711733,303272,455559,272543,673651,546743,314511,500718,563421,320526,580094,683280,993497,752135,1032206,271085,39415,775233,599681,271276,859431,419347,493042,302324,330010,743599,578118,459983,315393,366755,627003,1001865,64107,659093,243920,299655,37948,201903,278381,223317,782158,475928,448214,994567,491686,383006,205101,661633,129251,971480,210416,931927,79112,684347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]