SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026009 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026009 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753433,591494,124239,180974,557932,479578,367486,422192,235126,974510,783410,661208,142239,159205,797460,943739,565492,258025,911591,939470,636824,935140,296334,457499,586559,339443,805878,105227,184998,883695,437429,754907,789442,97094,1033335,684578,255462,445713,79110,53333,78100,500844,953337,142062,587814,805936,450351,703221,303544,162651,746933,22,955797,829824,183570,249770,148428,822058,80177,231221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]