SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201759 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201759 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710400,1039829,571216,130025,116572,796101,971476,1025078,264162,57686,629579,61495,200455,296014,534565,301622,961218,420063,352243,509038,927919,435233,7611,467091,712754,286505,523778,127590,953847,83855,483560,265986,601982,130251,912902,883836,166687,97759,742079,601150,375678,152057,690747,647389,1048728,975779,361053,197676,36874,41534,502352,1045571,827987,590760,885029,138456,274214,500691,800301,690876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201759 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201759 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]