SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286150 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286150 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646654,460585,135174,439488,516504,552241,705744,897583,423600,184425,860328,383484,398377,553748,640661,17542,790914,300091,579283,478493,819489,319933,23580,442306,354481,940570,455997,137425,255893,1030246,977334,148593,147900,788125,73396,674310,775502,60163,137272,536869,119348,548950,364380,995826,1034274,697307,798954,418116,458754,750874,785858,444454,917133,122338,610228,21913,3625,987762,252946,173323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]