SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341480 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341480 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228750,48717,880623,264335,841229,573150,247773,95019,724002,257047,963583,363893,436851,871706,9258,392402,1033059,653410,148902,158618,226391,271920,26811,400326,121333,544751,94354,751414,77758,110316,449662,75021,437685,919521,808982,916404,352356,455174,376591,105966,96407,150041,469750,831289,882436,728637,26373,946271,77731,190246,564374,222964,848884,880912,965650,948309,686258,897233,49577,1003580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]