SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422916 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422916 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222836,905731,709362,323338,232130,222447,507942,1024270,788460,912805,705444,947689,204410,399416,384689,299720,988376,688526,125527,761544,779689,720300,691563,968580,177217,753446,934468,581487,688391,521120,434170,335877,394154,266215,339190,40070,620982,217326,350612,430224,441338,695416,380092,422495,722022,1012411,440875,473377,957409,689088,255953,1016204,423717,548676,803628,1012145,723160,8547,232366,720312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]