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` = 532926 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532926 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019229,744100,597588,29300,816750,122406,532951,836669,376074,422233,391918,612714,693731,124287,576077,481358,91380,334540,289017,903991,673824,198085,170964,674232,762325,40023,746752,972453,677700,423215,768342,912791,327886,83162,193390,1008702,383774,242708,931769,79121,230469,544047,705244,705294,408846,507912,220225,555340,4256,621866,882888,561747,1034471,140111,523813,45333,446051,824223,638012,604986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]