SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502995 LIMIT 1 [ RunTime:0.000993s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502995 [ RunTime:0.002893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776413,789544,401790,761707,515725,995397,536813,335570,661181,945409,827469,640910,101877,1043359,838357,421982,741616,424262,838486,44423,294741,613815,684214,415103,7707,457733,585922,295542,127871,240120,707727,457338,501413,1019645,732733,526736,54670,255430,362943,116462,614028,606937,668485,841408,1005120,919077,333377,507164,717514,717332,796552,1003531,1008625,897296,1030385,959099,511558,616194,933743,343488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001516s ]