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` = 1019158 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019158 [ RunTime:0.002253s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8545,1005210,243652,104358,1007889,289086,271762,66484,878593,81821,103542,715891,433861,723787,456046,609172,619307,802892,673020,326139,1044510,360306,874798,972040,933402,505092,529314,424522,330102,583709,841969,214155,169868,847925,353455,250407,611084,289717,620283,67652,559753,581388,429453,341974,561426,886000,859173,58046,727548,714025,266927,6865,1017490,389308,967626,133647,24353,724233,731986,9849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000787s ]