SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422114 LIMIT 1 [ RunTime:0.001995s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422114 [ RunTime:0.005854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534493,427881,1000395,53085,905127,586577,176973,122972,581193,941477,991622,78097,416074,579772,306725,959014,696749,900191,96734,1015641,540845,264372,539820,23013,627426,311750,898250,1008590,193963,84918,927737,466740,213017,712919,541139,608044,199805,18056,929056,766187,146377,56138,39310,173988,195576,181251,230395,127116,106984,233906,717883,786322,894993,559049,917542,218285,630303,32860,26078,165781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]