SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 714400 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 714400 [ RunTime:0.002656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367146,1001985,732332,141677,422468,11349,128648,153397,472354,414037,1027940,27443,514493,501320,250689,616690,917348,61668,10350,1029743,801021,261528,883148,21989,249919,173028,787375,225788,158564,421796,5308,608470,628586,368814,897702,634764,602663,513810,158814,1002428,595152,936782,396094,941314,829421,125841,791691,922137,255669,116766,740820,387047,977337,169646,611011,392473,26582,746750,175326,909939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 714400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 714400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]