SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021082 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021082 [ RunTime:0.002200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628444,527850,450329,392433,716218,901451,847243,713275,171083,317964,190416,160227,410145,298537,994447,29471,264745,528083,497376,605404,219754,13587,843961,806256,629291,967973,498610,989599,74625,963899,857222,387923,213485,754442,828992,77496,74774,71213,416914,46252,288940,66069,12322,137084,804082,246014,927943,467891,366448,450583,606456,732278,154323,639378,865761,461579,460089,359197,514008,525013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]