SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478028 LIMIT 1 [ RunTime:0.001050s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478028 [ RunTime:0.004150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772163,486680,191582,1042018,1006642,600491,503667,334325,167287,577114,623671,703568,50342,190129,94862,302036,500987,845324,1042147,737593,981882,554380,390191,841868,536753,478750,118824,66344,87555,153180,868507,356434,792468,933428,649052,94052,864258,952902,566731,119089,160089,294101,349257,103477,159250,763892,610306,87040,659462,282988,171232,358039,608733,1043143,9785,529407,750079,1023905,273870,283761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]