SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465063 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465063 [ RunTime:0.002935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599383,766267,874889,186863,930054,955000,626511,102886,1018776,486626,824594,1015421,273380,125476,656519,567092,497583,773545,681495,675610,525925,651167,1022158,476051,998411,746341,952951,783129,37593,829435,437783,1019129,176004,750007,761402,568264,617919,822944,387925,785298,158879,80477,238855,129214,159907,783068,667287,392864,1021310,762863,377947,248788,169943,166101,407351,448665,53405,89524,1048501,178262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]