SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10776 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10776 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396925,389367,539798,295173,938554,163660,476528,602183,971939,296030,1046780,360418,485167,856187,873499,208437,787191,502561,511274,216620,53755,330031,410107,331602,105609,417477,681155,764429,753023,1042289,816122,760659,316660,92103,166826,1046581,8490,998800,1034885,380456,446356,699572,608785,278689,482713,217010,441503,305287,944031,955026,325996,741590,77728,884647,576594,109914,162468,844800,528635,121218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001229s ]