SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58010 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58010 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427717,421572,156008,916788,1025663,57969,281981,504466,576011,571158,604474,1022698,873503,939816,783587,151237,215295,979950,934722,141393,1027847,385727,811033,387058,333294,416180,529341,155397,395629,338732,715248,724512,371708,619695,108533,595560,23295,94997,21253,366561,975570,610911,37416,933348,62038,869805,1008777,407656,875158,774786,673312,228953,6843,897635,891723,438843,978357,167418,846166,1043298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]