SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504484 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504484 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130884,876750,357131,732273,264662,231788,400032,439215,540297,971034,121406,505141,469915,149070,1002674,716314,431981,923990,504744,137182,532839,84804,204199,263881,151744,487535,931666,998081,766333,1037570,459390,418589,535648,147298,732183,841152,219999,298108,893046,605396,817697,755640,960813,945857,904602,921766,793825,16407,917433,592176,138121,187887,804048,1026183,955621,566720,475670,462275,995068,816655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]