SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50437 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50437 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614254,700791,275059,135399,932856,264364,542051,331303,606687,1029720,989280,489122,644901,287432,582556,410677,112899,101390,623617,503112,688748,350655,924907,975990,682720,169737,779314,17964,545437,695408,701586,789038,981634,295397,461609,403478,191342,711067,574691,880116,817376,797675,596008,573322,662526,600467,73789,435345,603541,591865,740674,204476,67238,423974,258684,79642,385465,334648,4983,983508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]