SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101433 LIMIT 1 [ RunTime:0.002791s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101433 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938001,548409,500159,183460,974823,843883,948317,248383,646235,982979,454698,801371,10834,805369,701694,580925,967274,241688,807000,857319,122182,569761,534146,308943,253960,282177,526660,280873,5681,1017427,532448,758376,571710,145704,713693,140710,188023,196546,107452,393973,603378,168337,596107,965642,496429,732105,192075,549942,1015837,488097,824039,886976,983399,88684,188516,139669,157042,216703,656980,605192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001824s ]