SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285991 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285991 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706997,383613,195859,448003,714712,1000094,92299,179514,1048098,485643,780917,91822,436412,691912,744082,318279,255321,898573,304720,516986,675466,721601,909825,376644,699871,719925,456605,287601,200652,581652,541264,702567,792850,148726,628046,85175,1013910,919362,1005401,192189,392923,874739,801996,37020,410871,351293,269794,995591,140885,519000,54666,960860,165820,172258,625022,771523,522018,82821,763283,173765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]