SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972014 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972014 [ RunTime:0.002542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461523,646118,564527,840963,4515,849448,790662,449192,649569,37625,801052,1001600,886932,130921,1012035,287943,851800,844920,617865,64989,899367,7449,99141,567220,766826,892946,838932,529597,881367,303206,756001,5563,1034468,295303,402288,841417,561667,1013922,390263,1016835,1017716,299616,66573,611910,553301,142652,732872,668258,872372,1046247,480917,303455,294899,966770,224275,830165,470307,603504,823430,724052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006136s ]