SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681811 LIMIT 1 [ RunTime:0.001291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681811 [ RunTime:0.002833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959878,1016161,39569,407833,802138,648197,1038940,965864,994700,273207,123258,800757,666909,533028,924422,955529,499312,396611,54452,611021,206377,543595,838566,10853,299805,306995,992224,1021423,581267,484316,128461,53695,497426,641958,544836,472860,759134,576945,332372,284936,908255,459477,466696,870593,858731,517862,534815,869467,742826,557523,629058,762960,167840,902589,604351,1028368,345754,809274,410235,257236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001015s ]