SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305222 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305222 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7986,548104,863186,881255,364181,926140,1008010,106712,114005,633116,614222,34711,81439,1032484,356301,346471,995771,902049,240022,86526,615879,185469,531851,914473,171052,838920,965960,231326,137795,135447,546649,583659,157099,860543,598912,328299,790126,467075,92645,301972,856208,989725,1026527,550472,48873,488383,136685,490121,78203,490840,692196,109611,110735,869726,660778,125106,519123,408280,167684,146033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]