SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335226 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335226 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942839,193358,962843,520127,455283,298679,43090,310689,260775,785314,5494,805636,425048,875733,914378,66152,89857,583480,67310,985942,979133,87688,693227,827424,838754,642185,640108,917948,125423,496657,981584,332059,467071,367242,689411,445345,314481,172212,237761,152672,584492,759845,584062,772143,1036636,997995,787621,122836,377180,773854,671604,859334,536461,920144,179871,523842,52800,866496,189047,643295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]