SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804009 LIMIT 1 [ RunTime:0.000576s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804009 [ RunTime:0.005013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158686,613266,574156,260131,225774,501493,93263,1000563,16611,964374,651937,1011246,21804,607514,952195,809215,277163,9127,520915,215108,819748,622596,216380,113799,522303,431654,438147,260056,655370,191006,751341,870704,451995,229159,97006,772730,147667,420415,208362,1039504,646666,756448,842212,733677,49329,444668,208762,142949,432327,384175,157962,985109,381566,324145,349255,839383,716863,389887,456896,277358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]