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` = 541672 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541672 [ RunTime:0.002808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312309,841944,282392,258715,453691,179116,289578,310118,271514,75717,25534,703389,1012496,30355,665864,225872,440222,15218,156615,779773,663113,530496,626673,118194,963500,1037733,420836,181251,502097,815266,936784,133081,442789,276883,313945,513580,474791,128539,301820,947082,849418,370478,1027438,49127,258449,143520,431756,214599,684249,127113,630921,444360,210588,676265,675109,626429,340363,1001737,408278,65296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541672 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541672 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]