SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34140 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34140 [ RunTime:0.001443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906637,188420,304225,438850,749850,435941,369444,849974,387445,863702,1032868,609562,66597,780859,876060,1039755,390643,489698,938278,814846,1021410,1036426,577629,740221,118139,556171,803012,184654,811561,20955,37837,256615,1008792,382538,791033,129188,647504,763470,353976,404816,195637,750000,319277,639126,326688,603035,512667,991153,706280,711801,204504,295751,799429,284668,292310,490303,738911,836727,243658,942181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]