SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419413 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419413 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125283,690281,378301,666555,413234,201040,1019331,1042424,30585,975656,338050,920652,99689,711858,585166,797872,260978,402879,97529,1019847,356500,375579,675077,1000747,332816,844917,1045620,837963,689063,814328,238169,211246,292161,698390,152858,48640,1031718,550019,499883,739963,787637,192947,943542,1042191,594706,600964,340204,402537,713079,996535,818175,927389,319494,581014,115075,750510,296026,851696,581948,372915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]