SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314410 LIMIT 1 [ RunTime:0.001431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314410 [ RunTime:0.003551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226785,570275,292266,748256,766677,525244,585668,464941,58800,592658,578900,608857,329108,25140,231599,325090,233844,1042319,223084,450936,194561,206186,730381,815649,640768,832337,943446,266614,599118,582811,328977,458902,583842,812220,956649,485024,220098,233810,275583,67274,27944,1024225,600290,357481,976920,952139,783680,604409,733676,141374,233341,446142,178771,860548,264501,202306,950973,494900,13471,588526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]