SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343681 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343681 [ RunTime:0.003097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72714,589255,138475,891443,297556,616771,837717,396958,154212,798372,428914,991478,704891,826854,415576,919517,286142,865186,943919,1008407,149689,255529,206434,138181,960182,496938,571899,20190,634021,700249,865318,520239,330962,101896,695711,26401,13078,412849,63604,822262,458627,937410,257806,351833,963380,142830,237367,500861,513932,935334,608756,273074,338248,43004,545488,724285,282492,939318,899023,614761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000871s ]