SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001735s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018845 LIMIT 1 [ RunTime:0.000833s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018845 [ RunTime:0.002873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124304,87474,155545,470037,639498,195046,105412,245653,476262,901198,441986,21415,52616,279446,53884,230236,389482,443201,643617,715191,833724,548265,371065,238164,48422,728649,643468,149532,709274,649907,520893,468008,1036385,646823,779978,450630,697835,216571,455145,77735,1013135,956275,725200,235086,237198,312928,768997,90647,281451,769055,704850,177546,230722,1006374,431513,933716,117978,446784,522304,996189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]