SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509693 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509693 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271752,869416,365098,104385,1007010,637227,151761,628261,871991,794598,697943,877204,1014505,376989,670305,1036917,141193,983095,571324,21324,926588,53707,145121,134864,25434,422237,675323,239217,799665,575884,452112,89645,486278,757646,789046,1007941,719826,184923,841516,523685,934710,799855,990513,377646,86610,379112,103049,957693,259479,604800,1007920,88540,692953,254086,845155,350825,37375,610549,991204,912222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001775s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]