SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10343 LIMIT 1 [ RunTime:0.002084s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10343 [ RunTime:0.006877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010308,770617,138148,106802,180821,740860,770536,332603,763930,90204,732060,828321,471866,148593,563209,215268,175217,826942,524310,342108,940114,316814,599064,137945,548907,516870,704924,133060,749740,576771,832373,123474,754841,136294,835228,881815,332060,919944,26765,850891,279964,674618,500598,432017,529599,427831,654474,571332,159264,912613,139898,81661,264626,139477,202995,440395,885470,862580,651730,490209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]