SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430598 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430598 [ RunTime:0.001346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252118,401964,1017918,1040260,611418,927917,1018447,347083,799375,222425,367210,995448,757536,617383,819022,931039,968034,172520,422304,943638,213553,670573,580911,142014,850058,510014,139325,905091,780704,454616,822574,206840,844398,802220,1029479,162158,106760,201387,231737,132202,551143,191470,604374,568863,439393,182548,411813,902879,903911,243178,127805,813676,269473,105009,276256,194409,670593,536017,56181,727492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]