SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001807s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011704 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011704 [ RunTime:0.002482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500239,704652,802231,529758,336414,963455,265274,862357,99493,219028,930852,382560,654076,286336,997430,451744,575701,192427,500087,681473,968437,199318,15563,88362,278568,763637,821741,424266,633952,1034398,731575,274131,13065,373453,1011164,149262,548313,921716,124879,495193,409538,362161,253060,126237,194977,821230,359789,699364,912819,24204,877972,678183,1005801,745789,266113,868249,994709,179891,860009,452588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002989s ]