SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407448 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407448 [ RunTime:0.004538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128194,296947,1023405,4232,1247,1024958,957125,944041,715925,715042,971906,613406,534922,741545,564182,713720,667150,446840,870643,410233,838874,342192,844921,762094,819605,948188,1028096,213977,143899,40043,550313,611878,779312,597166,912283,1033045,597639,525598,85433,97580,1006858,239600,835477,46411,497889,273143,915448,410884,126686,274845,805739,283255,757929,760358,151186,618995,835723,224430,212757,940276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]