SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001755s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333404 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333404 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5363,237080,74217,503094,397415,625570,281778,286028,618356,376984,782004,570775,952272,262620,200408,377270,1032998,930626,44626,170714,218288,1024733,922431,644907,597831,508824,898672,874770,689457,829384,1016212,964016,194056,411775,876121,703419,933442,63780,709467,215916,536806,759537,475543,414764,861458,976161,806762,551642,832484,505031,545771,996606,120283,618217,870639,993515,997846,207654,769241,59161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]