SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019622 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019622 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127646,688854,497563,989839,125719,256698,719829,200365,515468,950931,464592,512651,720381,18938,885203,113251,336937,264469,742997,934689,409479,700324,573110,401918,513989,524372,847891,453562,251617,69160,566702,847669,29697,22774,300067,874086,1013351,406533,837390,712606,1016376,219137,943589,630584,354007,1047002,1023248,819723,936129,510210,501194,724305,134493,703458,743299,173865,296997,49743,502079,752008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019622 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019622 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]