SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575211 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575211 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208020,1015618,566105,431672,411322,651385,290250,224383,614392,1024561,580250,1027052,55944,812939,423445,479111,905154,522527,890346,342136,1014691,359075,563582,454963,742446,456538,148696,1017890,356352,820509,1038885,312360,525189,456870,753210,905395,40641,762871,410953,596284,370815,2792,307644,1031116,158995,267843,868241,364123,535179,837038,18333,178573,926415,817062,486507,617899,607470,946665,825896,907312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]