SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424405 LIMIT 1 [ RunTime:0.001961s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424405 [ RunTime:0.005038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309255,907495,1042160,1005379,501009,84245,433716,372518,478643,1002771,659730,222103,1040984,777413,76330,293173,741393,558285,883673,170239,449098,206092,127067,964375,145263,387798,359196,664138,713404,1000901,1042794,71791,123874,885598,658790,433816,771044,522927,984833,988273,477696,108523,338184,164928,815793,377764,225560,370729,169115,838614,949598,127164,658662,134509,61341,265086,322083,288998,845915,437239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]