SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002973s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037293 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037293 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734141,33701,354422,297659,137437,125151,458319,242847,722668,160694,943940,762471,186614,201153,492132,569300,753804,65146,223541,368591,770615,157669,359229,772499,622894,245253,934691,391326,694962,904436,271995,204289,74737,607489,827314,407175,1021591,209491,111589,491636,623868,875650,351525,220599,675302,158865,99869,312139,553002,930662,576786,49061,785614,764520,147638,832010,637937,890677,266526,492634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]