SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039780 LIMIT 1 [ RunTime:0.002502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039780 [ RunTime:0.005633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580720,436186,380991,593976,1036173,885735,972158,184265,850284,485030,230647,635630,747155,1028598,804868,677794,617,598394,646401,626954,487246,708870,799765,673622,61994,835334,228693,88233,754149,645411,128366,113925,160980,980722,511629,289366,871,28896,247345,996089,629798,346312,264002,162262,847223,580681,536959,571971,1039832,140800,876243,763455,1008737,801781,1037456,1011071,581390,330095,556501,397829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]