SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563403 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563403 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418692,496031,481098,550314,1030858,345786,789759,408474,567191,730787,684158,16698,848021,118024,127571,112427,663902,796950,330681,590047,810022,783648,376554,668956,349136,1040373,336097,188716,693669,113198,152676,349957,964768,465666,508177,945016,553425,118067,308647,302438,926591,53098,763719,364901,356563,802307,137181,824671,764369,245808,107519,799816,74606,950881,590114,885831,418264,154186,622811,726845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]