SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405491 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405491 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286231,784679,809194,486076,776075,858035,75510,34801,710685,960975,308372,315251,489224,13858,687856,732953,230443,286689,779472,750345,191689,215140,285512,194479,512815,361553,28437,949221,264639,339560,526842,253861,825140,791651,748359,738751,302139,752109,262147,713284,139082,659541,484212,332446,253640,754545,635196,306006,559933,136741,124493,409366,936265,296275,881019,370542,329780,927773,824366,66825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001914s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001114s ]