SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033477 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033477 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294696,130422,794456,656475,389391,749090,203988,902361,968244,793575,642010,1013649,862694,596251,329911,823314,183274,614315,323412,142793,114357,801899,221190,764275,176742,617341,889815,624769,936535,841944,322084,1023990,42548,654737,29856,826913,744650,896216,566865,21336,519402,351059,674931,342570,363448,548487,838828,999636,963314,524749,496085,766511,107887,814593,332202,955374,1017782,154925,562841,796949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033477 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033477 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]