SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348753 LIMIT 1 [ RunTime:0.001656s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348753 [ RunTime:0.002446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201060,442072,371464,1023478,552000,1035380,213602,531219,598386,212019,970123,617614,674132,800234,960605,484882,393412,726733,33681,914035,37648,271188,383110,419522,304393,900569,974025,704116,532491,978110,557757,136084,350698,68282,641655,692485,724932,667905,27596,887560,881974,200770,202644,698406,6954,171601,984564,285663,115471,114276,341559,282265,839852,160326,1000651,537289,225985,654911,117804,544018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]