SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400452 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400452 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513391,678874,501074,819189,521244,161845,704337,1041542,285451,125353,772543,979966,971795,543502,182050,899903,122919,155666,265996,907160,881031,751242,1030907,782705,595206,784535,834074,33518,1026079,21084,1043709,990703,494720,367130,731245,434693,1004449,746389,69830,483478,617526,313154,809533,128938,330777,646440,633921,812344,234971,1001753,237710,448832,795887,102243,664444,706160,722425,504185,465176,489703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]