SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419097 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419097 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383025,913032,44185,915285,646098,195251,252138,514086,951813,87376,430200,987161,331399,519906,269282,88516,350158,875725,331038,980722,150848,893811,994877,354094,648772,745957,798850,479469,649373,402214,87733,151498,1005281,12575,429498,680908,445112,855293,270629,911020,593554,955284,602995,520725,819303,707690,332242,649047,64093,683740,918855,429495,503555,1016614,990244,443433,1043102,634608,403054,168780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003226s ]