SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300912 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300912 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019,758289,709953,723053,777846,781143,703211,869151,121616,108137,339622,756825,200157,414116,651253,237249,190064,62676,280186,847025,240492,505682,999132,445390,169707,292683,1043910,66025,938775,707036,130858,314503,239412,797576,362385,338243,845085,783821,115339,29142,480767,646847,108364,1030036,149615,768590,1006886,23394,41449,953544,712638,747037,311348,653143,538489,827048,913636,468821,33866,971833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]