SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002902s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910504 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910504 [ RunTime:0.003251s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115196,504081,1001530,91633,232397,819111,293832,317603,234588,854429,401312,182277,365433,447467,108715,514717,929364,131731,383793,856063,892123,751189,767669,750761,433834,507924,238343,393909,609257,942666,852432,461016,580193,476677,580723,307425,599283,875895,965014,656773,916568,900586,1045191,618503,576976,361554,843159,772284,1034452,296334,478523,1046769,55811,949638,59293,1006897,691116,302760,947723,245794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]