SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 636418 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 636418 [ RunTime:0.002343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924521,41501,869350,369908,205591,247531,454020,502590,203569,605307,398041,723587,220678,853712,432483,106426,117694,383500,817677,408003,23132,697467,358777,95261,44132,273313,696496,1048377,11480,451392,568549,612955,530973,217782,527972,598786,460185,380457,1042069,22523,240486,152871,167218,68951,1016497,511512,489302,873648,691999,469854,645521,617342,960265,344976,366800,144571,559903,51230,317685,257050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 636418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 636418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001543s ]