SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038800 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038800 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616542,293632,614491,659643,618135,816856,880195,529422,590359,69057,692549,400610,362634,21646,919574,659391,31268,528734,819118,179925,327782,100724,612707,796427,793038,69669,958949,256874,475807,361788,376666,537933,967978,20665,186953,703696,308266,164122,808159,1029070,350224,1040604,453708,570750,721909,595529,434665,703265,841179,400942,857990,179936,344963,316321,424607,527810,36938,355713,240187,502709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]