SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480088 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480088 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993042,875659,841661,1036448,429666,588761,918196,506872,244879,432636,286386,830242,915396,992800,727333,56385,512897,278204,167551,782435,487047,663933,436339,894617,1024269,387196,231709,463876,788623,176419,667518,676013,25467,858695,432311,584772,237157,92735,615863,885181,760858,465720,811845,1022575,969911,86719,259700,150439,606263,759414,747255,128728,871658,788402,512779,264376,189196,816555,147392,768244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]