SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427687 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427687 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35567,875093,267960,707514,14329,226302,841508,552314,448869,578837,722714,246027,711064,206030,256862,824245,545989,716649,416357,678063,723288,331957,647973,482373,1033961,986000,986208,106892,542462,364886,127754,899377,460764,586494,1025205,303026,354490,611775,175154,585930,133145,747772,331843,519997,58004,745789,826282,307414,875772,444117,678951,973906,884101,183456,141822,602416,552721,553115,449746,376272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]