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` = 1033167 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033167 [ RunTime:0.002983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422090,549627,85058,378565,255620,116250,529784,260138,75303,608346,631100,107285,551778,107441,978180,443738,675048,446395,722605,940058,287607,33470,662944,501859,1012868,128102,313976,495334,942381,396332,164922,390940,52567,413879,142319,889454,333771,179877,747418,551839,714926,178914,151356,191173,971690,907944,233913,665807,1007026,24362,487029,574778,735914,107821,1048101,965866,872486,381855,1041649,670634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033167 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033167 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]