SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45023 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45023 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342033,862940,859409,228912,823907,1040000,419046,709742,198817,756377,234136,705873,904613,71672,322796,281235,768624,395580,609081,630345,444108,10762,348347,281351,917400,621607,427371,534766,822908,852719,269772,902728,128713,63954,37816,717473,801791,582720,601083,640103,363385,641056,916626,319643,965937,337776,293342,115643,119679,265800,5044,961718,1012510,524370,95969,915402,811218,757208,386127,505791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]