SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428582 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428582 [ RunTime:0.004778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110153,578978,182655,333601,491264,810467,986716,921931,1020145,68687,647185,558976,580090,238368,741015,763591,909559,212705,424847,969738,1017458,9625,354037,818665,19384,325398,556863,821241,985321,569986,228968,463928,989894,336274,294549,878564,159854,982281,317162,636640,778825,151536,501926,143324,361877,915122,232071,741382,101796,61740,462191,767243,944222,741890,492209,292570,355024,264480,373832,122603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]