SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475801 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475801 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041462,77441,390400,554454,475448,673658,618287,199968,560782,1003754,427598,972829,675616,272200,623836,364565,487653,248500,243604,389163,340194,596742,915133,891667,6000,303470,987136,1030128,887554,995737,641527,775037,38975,646741,908115,591189,206492,816295,418441,407568,546059,207142,777155,497833,623167,944563,317670,207341,737910,654519,998837,933951,207436,157789,658053,228281,605390,85776,359258,554380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]