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` = 456293 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456293 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992385,118192,457584,949133,573622,97165,830694,490818,791944,160844,704191,54205,421763,918165,1018975,497411,76074,251127,481238,562074,193951,420465,988469,915013,803196,188452,680165,655716,765607,955156,20483,853264,225174,166702,754371,915585,267282,752806,635910,611706,77436,747793,458635,1037239,94423,719106,730333,913568,651866,1019793,757620,140574,215122,52400,904230,98385,447404,839163,799406,275185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]