SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541608 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541608 [ RunTime:0.003708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535752,743275,840593,144155,766960,970183,571152,11234,152516,687326,768001,273334,677251,945408,648472,818235,905815,292233,615369,594783,292246,373845,539797,1023535,936450,278215,313650,475842,387179,994237,56352,456614,228319,619473,706393,729933,1041272,92837,899025,747448,782966,541943,730025,219353,580291,604763,947693,946780,402574,1043632,509492,139058,189235,698031,825824,77295,923936,761048,226362,858009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]