SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540900 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540900 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41944,112600,496444,463438,422959,617955,463832,308212,566566,154444,927391,739536,788869,895138,1028436,256802,855312,245186,524896,651268,476832,382746,48393,773682,1042423,276918,473125,860328,305950,808441,183863,664840,232585,537463,927952,786138,168733,3141,735159,1039777,850683,372908,123567,826065,621353,35245,45517,534626,412529,487462,630698,897635,653096,802515,999463,225166,683344,429026,647347,374993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]