SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981513 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981513 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535080,329294,68959,169474,601639,97947,603938,269749,693421,207653,619684,939000,237080,532982,656946,470179,293219,13199,987183,432871,662337,865932,75766,245398,851651,369596,816943,140899,13357,677187,727372,181297,18431,671973,845384,1021323,302057,751181,817873,734918,545761,499931,876489,55517,1024603,944362,115638,340528,409383,805053,739375,829686,169119,379883,668688,468758,271501,922774,728779,445575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]