SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511293 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511293 [ RunTime:0.003208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798100,269388,936902,57204,147245,401651,1025866,789160,442082,637354,775289,909261,729223,333143,628267,672596,236495,512671,864441,1022892,734064,228844,928934,720764,857621,291896,1026823,952885,600596,340471,5263,686692,377844,1021717,540248,509782,774367,880978,770261,1046453,273351,553438,794461,349409,273629,65293,770399,427063,189336,894806,310740,938526,613232,472162,196475,86291,549565,1031795,958886,636282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004031s ]