SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47114 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47114 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684508,321047,797471,149032,1018316,724100,1030615,645426,594202,323291,82579,1026622,538980,417843,813333,281436,447867,625664,1022759,170677,217821,992566,700945,350388,193715,964139,143019,936165,238196,269443,1017982,757995,938921,889249,1020996,332008,49642,602226,706041,467580,575412,464798,392475,53568,986899,330430,247932,352301,759498,535991,14293,70483,343054,316978,31094,917506,782468,709165,7734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]