SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536518 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536518 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105193,1025465,991403,474127,556914,853468,155433,745464,383957,540434,29815,839575,333301,724180,702013,30458,221251,984802,447253,877181,614684,960699,660293,982506,519242,106576,331486,274863,976604,981879,19899,78608,769807,969658,583232,430219,337666,765502,955590,615395,665700,492636,458446,145367,870434,79473,91819,130180,392016,1044108,478933,382118,607456,733605,190657,176938,853394,211520,875475,477310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]