SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406208 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406208 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996147,647466,916752,197470,637292,64532,908358,599959,150588,587870,927970,971087,267375,504296,144571,100850,223790,470990,274849,761473,577793,1010271,393937,449139,1032849,314347,728269,440223,950914,89743,98586,457293,476992,817574,740651,593230,792515,983125,248444,747340,78365,889244,691825,118671,1016940,135160,223507,901709,159301,643785,558878,1010502,1036182,61971,641342,974241,1028289,535215,461008,400911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001374s ]