SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439022 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439022 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246536,635997,193823,1021264,491273,454719,523682,785744,87851,470280,47209,685983,551980,773508,1032458,952508,908618,899003,550714,1012098,854109,314991,752488,45411,83128,494724,459353,731889,907781,390680,909631,895734,1006886,328905,906008,500844,15961,571596,848203,493735,697627,973289,51150,677493,816165,427706,609730,675429,165346,80005,754141,253527,746423,358914,759800,461802,836507,636469,143859,870624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]