SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415621 LIMIT 1 [ RunTime:0.004038s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415621 [ RunTime:0.006077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612041,52520,403636,805485,298005,704059,665775,996119,157921,383372,748200,862154,549269,20189,393225,688454,110374,555227,537873,676789,63705,749528,704065,215706,266567,754161,276891,186994,252254,110131,894674,64878,676647,444603,484168,1043781,771531,283974,77012,618225,108415,605582,857237,246780,915637,730836,685034,852141,46576,136080,439773,557918,859050,316017,39290,354147,409433,393671,736223,31882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]