SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001837s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80411 LIMIT 1 [ RunTime:0.000739s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80411 [ RunTime:0.002498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243312,770874,107280,818943,271161,428400,160108,999418,977188,832500,358351,787249,933025,369952,641044,755157,902032,755453,29052,63198,1004057,531599,122760,677769,763489,73102,726806,903911,151068,357440,923013,859859,823711,684963,860439,949556,150729,194701,200274,577938,349976,615164,82022,219918,125817,185911,655397,184825,880830,931460,434424,562765,1040971,903710,270685,258933,11791,218000,401434,110723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]