SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020407 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020407 [ RunTime:0.002048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663697,67250,279182,343805,255590,501567,1029822,942004,567215,300556,138233,672119,119625,143106,178591,364051,994515,470700,183455,376859,214528,982074,148507,993078,214661,943868,367449,34659,777508,130218,186688,288903,264433,237551,35558,909353,45037,36603,730286,831096,769038,619434,661152,659401,795966,997156,945237,36648,540849,156474,90403,874801,384450,587399,527125,577243,125349,407668,183359,548895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]