SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458645 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458645 [ RunTime:0.002660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574930,361839,619910,106935,123475,320494,303992,519061,331238,929878,478817,364145,866157,301297,342886,858062,139525,199913,885079,614112,18801,291402,145830,114110,70820,686868,122712,10375,272544,549141,686304,351948,454856,730807,279051,390932,632705,270950,330465,60812,373606,58538,393705,771368,137924,43833,228475,196228,779829,848096,729655,437676,867568,678104,74217,409632,423892,297724,458088,942091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]