SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 123691 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 123691 [ RunTime:0.002913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156645,503029,880858,953198,366972,491702,974009,875728,618677,651822,283723,888150,737524,289755,557542,174135,961112,670301,858859,884558,232732,500295,972127,677719,916304,281144,355736,378650,307225,939270,687608,1028521,559580,331283,1001036,145027,312077,870408,409271,186962,397181,783806,1022923,594820,355841,967283,2855,119322,901025,914601,645372,439071,382575,803806,261515,13030,819864,749144,625139,581644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 123691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 123691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]